<?php
function create_exams_subjects_in_database($id) {
	$subject_id = DataBase::insert("subject", array("subject_name"=>"English", "global_mark"=>50, "selection_campaign_id"=>$id));
	$exam_copie_id = DataBase::insert("exam_copie", array("exam_copie_name"=>"English", "selection_campaign_id"=>$id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Spelling","subject_part_number"=>1,"subject_part_mark"=>11,"subject_part_nb_questions"=>11,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>1,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Vocabulary","subject_part_number"=>2,"subject_part_mark"=>10,"subject_part_nb_questions"=>10,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>2,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Grammar","subject_part_number"=>3,"subject_part_mark"=>15,"subject_part_nb_questions"=>15,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>3,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Conjugation","subject_part_number"=>4,"subject_part_mark"=>8,"subject_part_nb_questions"=>8,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>4,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Comprehension","subject_part_number"=>5,"subject_part_mark"=>6,"subject_part_nb_questions"=>6,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>5,"exam_copie_subject_part_id"=>$sp_id));

	$exam_copie_id = DataBase::insert("exam_copie", array("exam_copie_name"=>"Math + Logic", "selection_campaign_id"=>$id));
	
	$subject_id = DataBase::insert("subject", array("subject_name"=>"Logic", "global_mark"=>50, "selection_campaign_id"=>$id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Series","subject_part_number"=>1,"subject_part_mark"=>15,"subject_part_nb_questions"=>11,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>3,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Affiliated meanings","subject_part_number"=>2,"subject_part_mark"=>8,"subject_part_nb_questions"=>8,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>4,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Logical problems","subject_part_number"=>3,"subject_part_mark"=>27,"subject_part_nb_questions"=>13,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>7,"exam_copie_subject_part_id"=>$sp_id));

	$subject_id = DataBase::insert("subject", array("subject_name"=>"Math", "global_mark"=>50, "selection_campaign_id"=>$id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Calculus","subject_part_number"=>1,"subject_part_mark"=>13,"subject_part_nb_questions"=>10,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>1,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Operation","subject_part_number"=>2,"subject_part_mark"=>6,"subject_part_nb_questions"=>6,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>2,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Arithmetic","subject_part_number"=>3,"subject_part_mark"=>6,"subject_part_nb_questions"=>3,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>5,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Geometry","subject_part_number"=>4,"subject_part_mark"=>5,"subject_part_nb_questions"=>2,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>6,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Math problem","subject_part_number"=>5,"subject_part_mark"=>20,"subject_part_nb_questions"=>13,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>8,"exam_copie_subject_part_id"=>$sp_id));

	$subject_id = DataBase::insert("subject", array("subject_name"=>"Speed and accuracy", "global_mark"=>50, "selection_campaign_id"=>$id));
	$exam_copie_id = DataBase::insert("exam_copie", array("exam_copie_name"=>"Speed and accuracy", "selection_campaign_id"=>$id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Same item","subject_part_number"=>1,"subject_part_mark"=>4.5,"subject_part_nb_questions"=>9,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>1,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Underlined item","subject_part_number"=>2,"subject_part_mark"=>5,"subject_part_nb_questions"=>10,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>2,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Odd item","subject_part_number"=>3,"subject_part_mark"=>5.5,"subject_part_nb_questions"=>11,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>3,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Wrong pair","subject_part_number"=>4,"subject_part_mark"=>5,"subject_part_nb_questions"=>10,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>4,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Biggest number","subject_part_number"=>5,"subject_part_mark"=>5,"subject_part_nb_questions"=>10,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>5,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Smallest number","subject_part_number"=>6,"subject_part_mark"=>4.5,"subject_part_nb_questions"=>9,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>6,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Symmetric item","subject_part_number"=>7,"subject_part_mark"=>5,"subject_part_nb_questions"=>10,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>7,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Number category","subject_part_number"=>8,"subject_part_mark"=>5,"subject_part_nb_questions"=>10,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>8,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Item on the list","subject_part_number"=>9,"subject_part_mark"=>5,"subject_part_nb_questions"=>10,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>9,"exam_copie_subject_part_id"=>$sp_id));
	$sp_id = DataBase::insert("subject_part", array("subject_part_name"=>"Item not on the list","subject_part_number"=>10,"subject_part_mark"=>5.5,"subject_part_nb_questions"=>11,"subject_id"=>$subject_id));
	DataBase::insert("exam_copie_content", array("exam_copie_id"=>$exam_copie_id,"exam_copie_part_number"=>10,"exam_copie_subject_part_id"=>$sp_id));
}
?>